﻿CREATE PROCEDURE [dbo].[proc_MarketProjectItem_Create]
(
	@MID int,
	@T1 int,
	@T3 int,
	@Supplier nvarchar(50),
	@Contact nvarchar(30),
	@Phone nvarchar(30),
	@UnitPrice decimal(18,2),
	@Number int,
	@SpendingTotals decimal(18,2),
	@Person nvarchar(50),
	@Note nvarchar(500),
	@USERID VARCHAR(50),
	@SaveMark INT,
	@AccountLimit decimal(18,2),
	@ProfitsItem decimal(18,2)
)
AS
BEGIN

INSERT INTO [MarketProjectItem]
           (
           	[MID]
           ,[T1]
           ,[T3]
           ,[Supplier]
           ,[Contact]
           ,[Phone]
           ,[UnitPrice]
           ,[Number]
           ,[SpendingTotals]
           ,[Person]
           ,[Note]
           ,[USERID]
           ,[SaveMark]
           ,[AccountLimit]
           ,[ProfitsItem])
     VALUES
           (
           @MID,
           @T1,
           @T3,
           @Supplier,
           @Contact,
           @Phone,
           @UnitPrice,
           @Number,
           @SpendingTotals,
           @Person,
           @Note,
           @USERID,
           @SaveMark,
           @AccountLimit,
           @ProfitsItem
           )

	SET NOCOUNT ON;

END
